1. Right
Click the NO IT Exp worksheet and Duplicate it.
2. Rename worksheet to Age
3. Remove all pills from the columns and shelves
4. In the Marks Card, remove Gender and drag and drop _cc.GenderMale>Female,
in Color.
5. In the Marks Card remove cc.IT Exp% and drag and drop _cc.AgeMeasure AVG in the marks card indetail.
6. Drag Age
to Columns
7. Right click Null and select Hide.
8. Right
Click Age Header and Select Hide Field Labels for Rows
9. Right
Click in the sheet and Select Format.
10. Click on the Borders Icon and go down to Row Divider and select None.
11. Drag
_cc.Age MEASURE into Rows twice, side by side.
12. Right
Click the 2nd _cc.Age MEASURE and select dual Axis.
13. Make sure the 2nd _cc.Age MEASURE is highlighted. Go to it in the Marks
card and change the Shape to Bar.
14. In the
Marks Card, select Size and make the Bar skinny like a Petal.
15. Click on
the First _cc.Age MEASURE in Rows. Make sure it is highlighted.
16. Go to
the Marks Card and change it from Automatic to Circle.
17. Click on Size to make it bigger(around 50%), like the top of a Lollipop.
18. Make sure the First _cc.Age MEASURE in Rows is Highlight. Press Ctrl
and Drag _cc.Age MEASURE onto Text(Label)
19. Click on
Text(label), then Alignment, then Select Automatic Center and Vertical Center
20. Again,
make sure the First _cc.Age MEASURE in Rosws is Highlight. In the Marks
Card, Right Click cc.Age
MEASURE and Select Quick Table Calculation and Percent of Total.
21. In the
Marks Card, right Click the Same Pill again and Select Format.
22. Go to
Numbers, Percentage and 0 decimal places.
23. Right Click the Right Axis and Select Synchronize.
24. Then right click All 3 Axes and Uncheck Show Header.
25. Click on
the top and select Entire View.
26. Right Click Title and select Hide Title
27. Go to the Age Worksheet. Click on Worksheet and click on Show
Title
28. Right click title and select edit
29. Insert _cc.AgemeasureAVG and type the word Age afterwards
How to do Lollipop Charts in Tableau :